package cn.yunhe.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ZhuyuanExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ZhuyuanExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andHosrIdIsNull() {
            addCriterion("hosR_id is null");
            return (Criteria) this;
        }

        public Criteria andHosrIdIsNotNull() {
            addCriterion("hosR_id is not null");
            return (Criteria) this;
        }

        public Criteria andHosrIdEqualTo(Integer value) {
            addCriterion("hosR_id =", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdNotEqualTo(Integer value) {
            addCriterion("hosR_id <>", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdGreaterThan(Integer value) {
            addCriterion("hosR_id >", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_id >=", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdLessThan(Integer value) {
            addCriterion("hosR_id <", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_id <=", value, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdIn(List<Integer> values) {
            addCriterion("hosR_id in", values, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdNotIn(List<Integer> values) {
            addCriterion("hosR_id not in", values, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdBetween(Integer value1, Integer value2) {
            addCriterion("hosR_id between", value1, value2, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrIdNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_id not between", value1, value2, "hosrId");
            return (Criteria) this;
        }

        public Criteria andHosrNameIsNull() {
            addCriterion("hosR_name is null");
            return (Criteria) this;
        }

        public Criteria andHosrNameIsNotNull() {
            addCriterion("hosR_name is not null");
            return (Criteria) this;
        }

        public Criteria andHosrNameEqualTo(String value) {
            addCriterion("hosR_name =", value, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameNotEqualTo(String value) {
            addCriterion("hosR_name <>", value, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameGreaterThan(String value) {
            addCriterion("hosR_name >", value, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_name >=", value, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameLessThan(String value) {
            addCriterion("hosR_name <", value, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameLessThanOrEqualTo(String value) {
            addCriterion("hosR_name <=", value, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameLike(String value) {
            addCriterion("hosR_name like", value, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameNotLike(String value) {
            addCriterion("hosR_name not like", value, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameIn(List<String> values) {
            addCriterion("hosR_name in", values, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameNotIn(List<String> values) {
            addCriterion("hosR_name not in", values, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameBetween(String value1, String value2) {
            addCriterion("hosR_name between", value1, value2, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrNameNotBetween(String value1, String value2) {
            addCriterion("hosR_name not between", value1, value2, "hosrName");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarIsNull() {
            addCriterion("hosR_idCar is null");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarIsNotNull() {
            addCriterion("hosR_idCar is not null");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarEqualTo(String value) {
            addCriterion("hosR_idCar =", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarNotEqualTo(String value) {
            addCriterion("hosR_idCar <>", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarGreaterThan(String value) {
            addCriterion("hosR_idCar >", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_idCar >=", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarLessThan(String value) {
            addCriterion("hosR_idCar <", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarLessThanOrEqualTo(String value) {
            addCriterion("hosR_idCar <=", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarLike(String value) {
            addCriterion("hosR_idCar like", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarNotLike(String value) {
            addCriterion("hosR_idCar not like", value, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarIn(List<String> values) {
            addCriterion("hosR_idCar in", values, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarNotIn(List<String> values) {
            addCriterion("hosR_idCar not in", values, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarBetween(String value1, String value2) {
            addCriterion("hosR_idCar between", value1, value2, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrIdcarNotBetween(String value1, String value2) {
            addCriterion("hosR_idCar not between", value1, value2, "hosrIdcar");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalIsNull() {
            addCriterion("hosR_medical is null");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalIsNotNull() {
            addCriterion("hosR_medical is not null");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalEqualTo(String value) {
            addCriterion("hosR_medical =", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalNotEqualTo(String value) {
            addCriterion("hosR_medical <>", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalGreaterThan(String value) {
            addCriterion("hosR_medical >", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_medical >=", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalLessThan(String value) {
            addCriterion("hosR_medical <", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalLessThanOrEqualTo(String value) {
            addCriterion("hosR_medical <=", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalLike(String value) {
            addCriterion("hosR_medical like", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalNotLike(String value) {
            addCriterion("hosR_medical not like", value, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalIn(List<String> values) {
            addCriterion("hosR_medical in", values, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalNotIn(List<String> values) {
            addCriterion("hosR_medical not in", values, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalBetween(String value1, String value2) {
            addCriterion("hosR_medical between", value1, value2, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrMedicalNotBetween(String value1, String value2) {
            addCriterion("hosR_medical not between", value1, value2, "hosrMedical");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceIsNull() {
            addCriterion("hosR_regPrice is null");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceIsNotNull() {
            addCriterion("hosR_regPrice is not null");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceEqualTo(Double value) {
            addCriterion("hosR_regPrice =", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceNotEqualTo(Double value) {
            addCriterion("hosR_regPrice <>", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceGreaterThan(Double value) {
            addCriterion("hosR_regPrice >", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("hosR_regPrice >=", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceLessThan(Double value) {
            addCriterion("hosR_regPrice <", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceLessThanOrEqualTo(Double value) {
            addCriterion("hosR_regPrice <=", value, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceIn(List<Double> values) {
            addCriterion("hosR_regPrice in", values, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceNotIn(List<Double> values) {
            addCriterion("hosR_regPrice not in", values, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceBetween(Double value1, Double value2) {
            addCriterion("hosR_regPrice between", value1, value2, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrRegpriceNotBetween(Double value1, Double value2) {
            addCriterion("hosR_regPrice not between", value1, value2, "hosrRegprice");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneIsNull() {
            addCriterion("hosR_phone is null");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneIsNotNull() {
            addCriterion("hosR_phone is not null");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneEqualTo(String value) {
            addCriterion("hosR_phone =", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneNotEqualTo(String value) {
            addCriterion("hosR_phone <>", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneGreaterThan(String value) {
            addCriterion("hosR_phone >", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_phone >=", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneLessThan(String value) {
            addCriterion("hosR_phone <", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneLessThanOrEqualTo(String value) {
            addCriterion("hosR_phone <=", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneLike(String value) {
            addCriterion("hosR_phone like", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneNotLike(String value) {
            addCriterion("hosR_phone not like", value, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneIn(List<String> values) {
            addCriterion("hosR_phone in", values, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneNotIn(List<String> values) {
            addCriterion("hosR_phone not in", values, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneBetween(String value1, String value2) {
            addCriterion("hosR_phone between", value1, value2, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrPhoneNotBetween(String value1, String value2) {
            addCriterion("hosR_phone not between", value1, value2, "hosrPhone");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceIsNull() {
            addCriterion("hosR_selfPrice is null");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceIsNotNull() {
            addCriterion("hosR_selfPrice is not null");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceEqualTo(Integer value) {
            addCriterion("hosR_selfPrice =", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceNotEqualTo(Integer value) {
            addCriterion("hosR_selfPrice <>", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceGreaterThan(Integer value) {
            addCriterion("hosR_selfPrice >", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_selfPrice >=", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceLessThan(Integer value) {
            addCriterion("hosR_selfPrice <", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_selfPrice <=", value, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceIn(List<Integer> values) {
            addCriterion("hosR_selfPrice in", values, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceNotIn(List<Integer> values) {
            addCriterion("hosR_selfPrice not in", values, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceBetween(Integer value1, Integer value2) {
            addCriterion("hosR_selfPrice between", value1, value2, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSelfpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_selfPrice not between", value1, value2, "hosrSelfprice");
            return (Criteria) this;
        }

        public Criteria andHosrSexIsNull() {
            addCriterion("hosR_sex is null");
            return (Criteria) this;
        }

        public Criteria andHosrSexIsNotNull() {
            addCriterion("hosR_sex is not null");
            return (Criteria) this;
        }

        public Criteria andHosrSexEqualTo(Integer value) {
            addCriterion("hosR_sex =", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexNotEqualTo(Integer value) {
            addCriterion("hosR_sex <>", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexGreaterThan(Integer value) {
            addCriterion("hosR_sex >", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_sex >=", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexLessThan(Integer value) {
            addCriterion("hosR_sex <", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_sex <=", value, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexIn(List<Integer> values) {
            addCriterion("hosR_sex in", values, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexNotIn(List<Integer> values) {
            addCriterion("hosR_sex not in", values, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexBetween(Integer value1, Integer value2) {
            addCriterion("hosR_sex between", value1, value2, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrSexNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_sex not between", value1, value2, "hosrSex");
            return (Criteria) this;
        }

        public Criteria andHosrAgeIsNull() {
            addCriterion("hosR_age is null");
            return (Criteria) this;
        }

        public Criteria andHosrAgeIsNotNull() {
            addCriterion("hosR_age is not null");
            return (Criteria) this;
        }

        public Criteria andHosrAgeEqualTo(Integer value) {
            addCriterion("hosR_age =", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeNotEqualTo(Integer value) {
            addCriterion("hosR_age <>", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeGreaterThan(Integer value) {
            addCriterion("hosR_age >", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_age >=", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeLessThan(Integer value) {
            addCriterion("hosR_age <", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_age <=", value, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeIn(List<Integer> values) {
            addCriterion("hosR_age in", values, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeNotIn(List<Integer> values) {
            addCriterion("hosR_age not in", values, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeBetween(Integer value1, Integer value2) {
            addCriterion("hosR_age between", value1, value2, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrAgeNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_age not between", value1, value2, "hosrAge");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorIsNull() {
            addCriterion("hosR_lookDoctor is null");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorIsNotNull() {
            addCriterion("hosR_lookDoctor is not null");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorEqualTo(String value) {
            addCriterion("hosR_lookDoctor =", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorNotEqualTo(String value) {
            addCriterion("hosR_lookDoctor <>", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorGreaterThan(String value) {
            addCriterion("hosR_lookDoctor >", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_lookDoctor >=", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorLessThan(String value) {
            addCriterion("hosR_lookDoctor <", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorLessThanOrEqualTo(String value) {
            addCriterion("hosR_lookDoctor <=", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorLike(String value) {
            addCriterion("hosR_lookDoctor like", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorNotLike(String value) {
            addCriterion("hosR_lookDoctor not like", value, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorIn(List<String> values) {
            addCriterion("hosR_lookDoctor in", values, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorNotIn(List<String> values) {
            addCriterion("hosR_lookDoctor not in", values, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorBetween(String value1, String value2) {
            addCriterion("hosR_lookDoctor between", value1, value2, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andHosrLookdoctorNotBetween(String value1, String value2) {
            addCriterion("hosR_lookDoctor not between", value1, value2, "hosrLookdoctor");
            return (Criteria) this;
        }

        public Criteria andDIdIsNull() {
            addCriterion("d_id is null");
            return (Criteria) this;
        }

        public Criteria andDIdIsNotNull() {
            addCriterion("d_id is not null");
            return (Criteria) this;
        }

        public Criteria andDIdEqualTo(Integer value) {
            addCriterion("d_id =", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdNotEqualTo(Integer value) {
            addCriterion("d_id <>", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdGreaterThan(Integer value) {
            addCriterion("d_id >", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("d_id >=", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdLessThan(Integer value) {
            addCriterion("d_id <", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdLessThanOrEqualTo(Integer value) {
            addCriterion("d_id <=", value, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdIn(List<Integer> values) {
            addCriterion("d_id in", values, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdNotIn(List<Integer> values) {
            addCriterion("d_id not in", values, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdBetween(Integer value1, Integer value2) {
            addCriterion("d_id between", value1, value2, "dId");
            return (Criteria) this;
        }

        public Criteria andDIdNotBetween(Integer value1, Integer value2) {
            addCriterion("d_id not between", value1, value2, "dId");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkIsNull() {
            addCriterion("hosR_remark is null");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkIsNotNull() {
            addCriterion("hosR_remark is not null");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkEqualTo(String value) {
            addCriterion("hosR_remark =", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkNotEqualTo(String value) {
            addCriterion("hosR_remark <>", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkGreaterThan(String value) {
            addCriterion("hosR_remark >", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("hosR_remark >=", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkLessThan(String value) {
            addCriterion("hosR_remark <", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkLessThanOrEqualTo(String value) {
            addCriterion("hosR_remark <=", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkLike(String value) {
            addCriterion("hosR_remark like", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkNotLike(String value) {
            addCriterion("hosR_remark not like", value, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkIn(List<String> values) {
            addCriterion("hosR_remark in", values, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkNotIn(List<String> values) {
            addCriterion("hosR_remark not in", values, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkBetween(String value1, String value2) {
            addCriterion("hosR_remark between", value1, value2, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrRemarkNotBetween(String value1, String value2) {
            addCriterion("hosR_remark not between", value1, value2, "hosrRemark");
            return (Criteria) this;
        }

        public Criteria andHosrStateIsNull() {
            addCriterion("hosR_state is null");
            return (Criteria) this;
        }

        public Criteria andHosrStateIsNotNull() {
            addCriterion("hosR_state is not null");
            return (Criteria) this;
        }

        public Criteria andHosrStateEqualTo(Integer value) {
            addCriterion("hosR_state =", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateNotEqualTo(Integer value) {
            addCriterion("hosR_state <>", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateGreaterThan(Integer value) {
            addCriterion("hosR_state >", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("hosR_state >=", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateLessThan(Integer value) {
            addCriterion("hosR_state <", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateLessThanOrEqualTo(Integer value) {
            addCriterion("hosR_state <=", value, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateIn(List<Integer> values) {
            addCriterion("hosR_state in", values, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateNotIn(List<Integer> values) {
            addCriterion("hosR_state not in", values, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateBetween(Integer value1, Integer value2) {
            addCriterion("hosR_state between", value1, value2, "hosrState");
            return (Criteria) this;
        }

        public Criteria andHosrStateNotBetween(Integer value1, Integer value2) {
            addCriterion("hosR_state not between", value1, value2, "hosrState");
            return (Criteria) this;
        }

        public Criteria andPIdIsNull() {
            addCriterion("p_id is null");
            return (Criteria) this;
        }

        public Criteria andPIdIsNotNull() {
            addCriterion("p_id is not null");
            return (Criteria) this;
        }

        public Criteria andPIdEqualTo(Integer value) {
            addCriterion("p_id =", value, "pId");
            return (Criteria) this;
        }

        public Criteria andPIdNotEqualTo(Integer value) {
            addCriterion("p_id <>", value, "pId");
            return (Criteria) this;
        }

        public Criteria andPIdGreaterThan(Integer value) {
            addCriterion("p_id >", value, "pId");
            return (Criteria) this;
        }

        public Criteria andPIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("p_id >=", value, "pId");
            return (Criteria) this;
        }

        public Criteria andPIdLessThan(Integer value) {
            addCriterion("p_id <", value, "pId");
            return (Criteria) this;
        }

        public Criteria andPIdLessThanOrEqualTo(Integer value) {
            addCriterion("p_id <=", value, "pId");
            return (Criteria) this;
        }

        public Criteria andPIdIn(List<Integer> values) {
            addCriterion("p_id in", values, "pId");
            return (Criteria) this;
        }

        public Criteria andPIdNotIn(List<Integer> values) {
            addCriterion("p_id not in", values, "pId");
            return (Criteria) this;
        }

        public Criteria andPIdBetween(Integer value1, Integer value2) {
            addCriterion("p_id between", value1, value2, "pId");
            return (Criteria) this;
        }

        public Criteria andPIdNotBetween(Integer value1, Integer value2) {
            addCriterion("p_id not between", value1, value2, "pId");
            return (Criteria) this;
        }

        public Criteria andCIdIsNull() {
            addCriterion("c_id is null");
            return (Criteria) this;
        }

        public Criteria andCIdIsNotNull() {
            addCriterion("c_id is not null");
            return (Criteria) this;
        }

        public Criteria andCIdEqualTo(Integer value) {
            addCriterion("c_id =", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdNotEqualTo(Integer value) {
            addCriterion("c_id <>", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdGreaterThan(Integer value) {
            addCriterion("c_id >", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("c_id >=", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdLessThan(Integer value) {
            addCriterion("c_id <", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdLessThanOrEqualTo(Integer value) {
            addCriterion("c_id <=", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdIn(List<Integer> values) {
            addCriterion("c_id in", values, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdNotIn(List<Integer> values) {
            addCriterion("c_id not in", values, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdBetween(Integer value1, Integer value2) {
            addCriterion("c_id between", value1, value2, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdNotBetween(Integer value1, Integer value2) {
            addCriterion("c_id not between", value1, value2, "cId");
            return (Criteria) this;
        }

        public Criteria andBIdIsNull() {
            addCriterion("b_id is null");
            return (Criteria) this;
        }

        public Criteria andBIdIsNotNull() {
            addCriterion("b_id is not null");
            return (Criteria) this;
        }

        public Criteria andBIdEqualTo(Integer value) {
            addCriterion("b_id =", value, "bId");
            return (Criteria) this;
        }

        public Criteria andBIdNotEqualTo(Integer value) {
            addCriterion("b_id <>", value, "bId");
            return (Criteria) this;
        }

        public Criteria andBIdGreaterThan(Integer value) {
            addCriterion("b_id >", value, "bId");
            return (Criteria) this;
        }

        public Criteria andBIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("b_id >=", value, "bId");
            return (Criteria) this;
        }

        public Criteria andBIdLessThan(Integer value) {
            addCriterion("b_id <", value, "bId");
            return (Criteria) this;
        }

        public Criteria andBIdLessThanOrEqualTo(Integer value) {
            addCriterion("b_id <=", value, "bId");
            return (Criteria) this;
        }

        public Criteria andBIdIn(List<Integer> values) {
            addCriterion("b_id in", values, "bId");
            return (Criteria) this;
        }

        public Criteria andBIdNotIn(List<Integer> values) {
            addCriterion("b_id not in", values, "bId");
            return (Criteria) this;
        }

        public Criteria andBIdBetween(Integer value1, Integer value2) {
            addCriterion("b_id between", value1, value2, "bId");
            return (Criteria) this;
        }

        public Criteria andBIdNotBetween(Integer value1, Integer value2) {
            addCriterion("b_id not between", value1, value2, "bId");
            return (Criteria) this;
        }

        public Criteria andZpriceIsNull() {
            addCriterion("zPrice is null");
            return (Criteria) this;
        }

        public Criteria andZpriceIsNotNull() {
            addCriterion("zPrice is not null");
            return (Criteria) this;
        }

        public Criteria andZpriceEqualTo(String value) {
            addCriterion("zPrice =", value, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceNotEqualTo(String value) {
            addCriterion("zPrice <>", value, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceGreaterThan(String value) {
            addCriterion("zPrice >", value, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceGreaterThanOrEqualTo(String value) {
            addCriterion("zPrice >=", value, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceLessThan(String value) {
            addCriterion("zPrice <", value, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceLessThanOrEqualTo(String value) {
            addCriterion("zPrice <=", value, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceLike(String value) {
            addCriterion("zPrice like", value, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceNotLike(String value) {
            addCriterion("zPrice not like", value, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceIn(List<String> values) {
            addCriterion("zPrice in", values, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceNotIn(List<String> values) {
            addCriterion("zPrice not in", values, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceBetween(String value1, String value2) {
            addCriterion("zPrice between", value1, value2, "zprice");
            return (Criteria) this;
        }

        public Criteria andZpriceNotBetween(String value1, String value2) {
            addCriterion("zPrice not between", value1, value2, "zprice");
            return (Criteria) this;
        }

        public Criteria andZRemarkIsNull() {
            addCriterion("z_remark is null");
            return (Criteria) this;
        }

        public Criteria andZRemarkIsNotNull() {
            addCriterion("z_remark is not null");
            return (Criteria) this;
        }

        public Criteria andZRemarkEqualTo(String value) {
            addCriterion("z_remark =", value, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkNotEqualTo(String value) {
            addCriterion("z_remark <>", value, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkGreaterThan(String value) {
            addCriterion("z_remark >", value, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("z_remark >=", value, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkLessThan(String value) {
            addCriterion("z_remark <", value, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkLessThanOrEqualTo(String value) {
            addCriterion("z_remark <=", value, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkLike(String value) {
            addCriterion("z_remark like", value, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkNotLike(String value) {
            addCriterion("z_remark not like", value, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkIn(List<String> values) {
            addCriterion("z_remark in", values, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkNotIn(List<String> values) {
            addCriterion("z_remark not in", values, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkBetween(String value1, String value2) {
            addCriterion("z_remark between", value1, value2, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZRemarkNotBetween(String value1, String value2) {
            addCriterion("z_remark not between", value1, value2, "zRemark");
            return (Criteria) this;
        }

        public Criteria andZTimeIsNull() {
            addCriterion("z_time is null");
            return (Criteria) this;
        }

        public Criteria andZTimeIsNotNull() {
            addCriterion("z_time is not null");
            return (Criteria) this;
        }

        public Criteria andZTimeEqualTo(Date value) {
            addCriterion("z_time =", value, "zTime");
            return (Criteria) this;
        }

        public Criteria andZTimeNotEqualTo(Date value) {
            addCriterion("z_time <>", value, "zTime");
            return (Criteria) this;
        }

        public Criteria andZTimeGreaterThan(Date value) {
            addCriterion("z_time >", value, "zTime");
            return (Criteria) this;
        }

        public Criteria andZTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("z_time >=", value, "zTime");
            return (Criteria) this;
        }

        public Criteria andZTimeLessThan(Date value) {
            addCriterion("z_time <", value, "zTime");
            return (Criteria) this;
        }

        public Criteria andZTimeLessThanOrEqualTo(Date value) {
            addCriterion("z_time <=", value, "zTime");
            return (Criteria) this;
        }

        public Criteria andZTimeIn(List<Date> values) {
            addCriterion("z_time in", values, "zTime");
            return (Criteria) this;
        }

        public Criteria andZTimeNotIn(List<Date> values) {
            addCriterion("z_time not in", values, "zTime");
            return (Criteria) this;
        }

        public Criteria andZTimeBetween(Date value1, Date value2) {
            addCriterion("z_time between", value1, value2, "zTime");
            return (Criteria) this;
        }

        public Criteria andZTimeNotBetween(Date value1, Date value2) {
            addCriterion("z_time not between", value1, value2, "zTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}